2017-03-16 - 22051 - Service Request-NE by you #SalesDistribution

Service Request

22051 - Get Revenue & Quantity for NE by You Orders

Problem Summary

---

Need to fetch revenue & Qty for given orders and group them by week.

Admin Info

---

Purpose	Need to fetch revenue & Qty for given orders and group them by week.
Requested by	Saravanan Lakshmanan
Issue Date	03-16-2017
Resolved by	Uday Kumar P
Resolved Date	03-17-2017
Document Status	Complete

Detailed Problem Description

---

Need to fetch revenue and qty for given sales orders of Purchasing Document Type 'B2B' and exclude cancelled or returned orders and group the orders by week.

Input File

SALES ORDER b2b.xlsx

Solution Analysis and Recommendations

---

1. Need to fetch Confirmed Qty, Confirmed Value, Order Qty & Order Value for given sales orders based on PO type 'B2B' and delivery date.
2. As week field is not directly available in Sales Order DSO, so need to develop new crystal report.
3. Need to create a new crystal report by taking excel dump from sales Order DSO as source.
4. Need to group all sales Orders by week and fetch Confirmed Qty, Confirmed Value, Order Qty & Order Value into the output spreadsheet.

Resolution

---

1. Fetched Confirmed Qty, Confirmed Value, Order Qty & Order Value for given sales orders based on PO type 'B2B' and delivery date.
2. Developed a new report as week field is not directly available in Sales Order DSO.
3. Used the excel dump from sales Order DSO as source for the new report.
4. Grouped all sales Orders by week and fetched Confirmed Qty, Confirmed Value, Order Qty & Order Value into the output spreadsheet.

Output File

SALES DS.csv

Release Information

---

None